// Crear la table si elle n'existe pas;
var db = Titanium.Database.open('names');
db.execute('CREATE TABLE IF NOT EXISTS names (id INTEGER PRIMARY KEY, name TEXT)');


Titanium.UI.setBackgroundColor('#000');

var tabGroup = Titanium.UI.createTabGroup();

var win = Ti.UI.createWindow({
	title:'Liste',
	backgroundColor:'#fff'
});
win.layout = 'vertical';

var data = [];
var rows = db.execute('SELECT * FROM names');
while(rows.isValidRow())
{
	data.push({
		title:rows.getFieldByName('name'),
		id: rows.getFieldByName('id')
	});
	
	rows.next();
}

// Pour la performance n'oublie pas de fermer la connexion
// quand nous n'en avez plus besoin
rows.close();

var tbSearch = Ti.UI.createSearchBar({
	hintText:'taper pour filtrer',
	showCancel:true
});

tbSearch.addEventListener('change', function(e)
{
  // search rows for value of string as user types
  e.source.value;
});
tbSearch.addEventListener('return', function(e)
{
  // dismiss the keypad when user presses return
  e.source.blur();
});
tbSearch.addEventListener('cancel', function(e)
{
  // dismiss the keypad when user presses the cancel button
  e.source.blur();
});

var table = Ti.UI.createTableView({
	data:data,
	search:tbSearch
	
});

win.add(table);

var tab1 = Titanium.UI.createTab({  
    icon:'KS_nav_views.png',
    title:'Liste',
    window:win
});

var win2 = Ti.UI.createWindow({
	title:'Create',
	layout:'vertical'
});

var label = Ti.UI.createLabel({
	text:'Indiquez un nom',
	top: 10,
	left:10,
});

win2.add(label);

var tbNom = Ti.UI.createTextField({
	top:10,
	left:10,
	width:150,
});
var currentName = '';
tbNom.addEventListener("change", function(e) {
  currentName = e.value;
  if (currentName == '') {
    buttonAdd.enabled = false;
  }
  else {
    buttonAdd.enabled = true;
  }
});

win2.add(tbNom);



var buttonAdd = Ti.UI.createButton({
	title:'Ajouter',
	top:10,
	left:10,
	enabled:false
});

buttonAdd.addEventListener('click', function(e)
{
	db.execute('INSERT INTO names (name) VALUES(?)',currentName);
	var last = db.execute("SELECT * FROM names ORDER BY id DESC LIMIT 1");
	table.appendRow({
      title:last.fieldByName('name'),
      id:last.fieldByName('id')
    });
});

win2.add(buttonAdd);

var tab2 = Titanium.UI.createTab({  
    icon:'KS_nav_views.png',
    title:'Nouveau',
    window:win2
});

tabGroup.addTab(tab1);  
tabGroup.addTab(tab2);  
tabGroup.open();

